Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 190 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 17.9 KiB |
| Average record size in memory | 96.7 B |
Variable types
| Categorical | 2 |
|---|---|
| Numeric | 10 |
Impressions is highly correlated with Ad Group and 6 other fields | High correlation |
Clicks is highly correlated with Ad Group and 6 other fields | High correlation |
CTR is highly correlated with Ad Group | High correlation |
Conversions is highly correlated with Impressions and 5 other fields | High correlation |
Conv Rate is highly correlated with Ad Group | High correlation |
Cost is highly correlated with Ad Group and 6 other fields | High correlation |
CPC is highly correlated with Ad Group | High correlation |
Revenue is highly correlated with Ad Group and 6 other fields | High correlation |
Sale Amount is highly correlated with Ad Group and 6 other fields | High correlation |
P&L is highly correlated with Impressions and 5 other fields | High correlation |
Ad Group is highly correlated with Impressions and 7 other fields | High correlation |
Ad Group is uniformly distributed | Uniform |
Month is uniformly distributed | Uniform |
Conversions has 7 (3.7%) zeros | Zeros |
Conv Rate has 7 (3.7%) zeros | Zeros |
Revenue has 8 (4.2%) zeros | Zeros |
Sale Amount has 7 (3.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-10-16 06:05:45.986982 |
|---|---|
| Analysis finished | 2022-10-16 06:06:16.119965 |
| Duration | 30.13 seconds |
| Software version | pandas-profiling v3.3.0 |
| Download configuration | config.json |
| Distinct | 40 |
|---|---|
| Distinct (%) | 21.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 KiB |
| Shop - 1:1 - Desk - [shop coupon code] | 5 |
|---|---|
| Shop - Phrase - Desk - Promo Code | 5 |
| Shop - Exact - Mob - Offer | 5 |
| Shop - Exact - Mob - Promo Code | 5 |
| Shop - Exact - Mob - Sale | 5 |
| Other values (35) |
Length
| Max length | 47 |
|---|---|
| Median length | 38 |
| Mean length | 32.64210526 |
| Min length | 25 |
Characters and Unicode
| Total characters | 6202 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | Shop - 1:1 - Desk - [shop coupon code] |
|---|---|
| 2nd row | Shop - 1:1 - Desk - [shop coupon] |
| 3rd row | Shop - 1:1 - Desk - [shop discount code] |
| 4th row | Shop - 1:1 - Desk - [shop promo code] |
| 5th row | Shop - 1:1 - Desk - [shop promo] |
Common Values
| Value | Count | Frequency (%) |
| Shop - 1:1 - Desk - [shop coupon code] | 5 | 2.6% |
| Shop - Phrase - Desk - Promo Code | 5 | 2.6% |
| Shop - Exact - Mob - Offer | 5 | 2.6% |
| Shop - Exact - Mob - Promo Code | 5 | 2.6% |
| Shop - Exact - Mob - Sale | 5 | 2.6% |
| Shop - Phrase - Desk - Coupon Code | 5 | 2.6% |
| Shop - Phrase - Desk - Discount Code | 5 | 2.6% |
| Shop - Phrase - Desk - Free Shipping | 5 | 2.6% |
| Shop - Phrase - Desk - Offer | 5 | 2.6% |
| Shop - Phrase - Desk - Sale | 5 | 2.6% |
| Other values (30) | 140 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 570 | ||
| shop | 240 | |
| mob | 96 | 6.4% |
| desk | 94 | 6.3% |
| code | 90 | 6.0% |
| exact | 72 | 4.8% |
| phrase | 68 | 4.6% |
| 1:1 | 50 | 3.3% |
| coupon | 40 | 2.7% |
| promo | 40 | 2.7% |
| Other values (9) | 134 | 9.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1304 | ||
| o | 654 | 10.5% |
| - | 570 | 9.2% |
| p | 358 | 5.8% |
| e | 352 | 5.7% |
| h | 328 | 5.3% |
| s | 242 | 3.9% |
| S | 230 | 3.7% |
| r | 170 | 2.7% |
| a | 166 | 2.7% |
| Other values (27) | 1828 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3330 | |
| Space Separator | 1304 | 21.0% |
| Uppercase Letter | 746 | 12.0% |
| Dash Punctuation | 570 | 9.2% |
| Decimal Number | 100 | 1.6% |
| Other Punctuation | 52 | 0.8% |
| Close Punctuation | 50 | 0.8% |
| Open Punctuation | 50 | 0.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 654 | |
| p | 358 | |
| e | 352 | |
| h | 328 | |
| s | 242 | 7.3% |
| r | 170 | 5.1% |
| a | 166 | 5.0% |
| c | 154 | 4.6% |
| t | 138 | 4.1% |
| d | 104 | 3.1% |
| Other values (11) | 664 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 230 | |
| D | 114 | |
| C | 100 | |
| M | 98 | |
| P | 88 | 11.8% |
| E | 72 | 9.7% |
| F | 22 | 2.9% |
| O | 20 | 2.7% |
| B | 2 | 0.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 50 | |
| / | 2 | 3.8% |
Space Separator
| Value | Count | Frequency (%) |
| 1304 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 570 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 100 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 50 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 50 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4076 | |
| Common | 2126 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 654 | |
| p | 358 | 8.8% |
| e | 352 | 8.6% |
| h | 328 | 8.0% |
| s | 242 | 5.9% |
| S | 230 | 5.6% |
| r | 170 | 4.2% |
| a | 166 | 4.1% |
| c | 154 | 3.8% |
| t | 138 | 3.4% |
| Other values (20) | 1284 |
Common
| Value | Count | Frequency (%) |
| 1304 | ||
| - | 570 | |
| 1 | 100 | 4.7% |
| ] | 50 | 2.4% |
| [ | 50 | 2.4% |
| : | 50 | 2.4% |
| / | 2 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6202 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1304 | ||
| o | 654 | 10.5% |
| - | 570 | 9.2% |
| p | 358 | 5.8% |
| e | 352 | 5.7% |
| h | 328 | 5.3% |
| s | 242 | 3.9% |
| S | 230 | 3.7% |
| r | 170 | 2.7% |
| a | 166 | 2.7% |
| Other values (27) | 1828 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 KiB |
| November | |
|---|---|
| July | |
| August | |
| September | |
| October |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.805263158 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1293 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| November | 39 | |
| July | 38 | |
| August | 38 | |
| September | 38 | |
| October | 37 |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| november | 39 | |
| july | 38 | |
| august | 38 | |
| september | 38 | |
| october | 37 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 229 | |
| b | 114 | 8.8% |
| r | 114 | 8.8% |
| u | 114 | 8.8% |
| t | 113 | 8.7% |
| m | 77 | 6.0% |
| o | 76 | 5.9% |
| N | 39 | 3.0% |
| v | 39 | 3.0% |
| s | 38 | 2.9% |
| Other values (9) | 340 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1103 | |
| Uppercase Letter | 190 | 14.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 229 | |
| b | 114 | |
| r | 114 | |
| u | 114 | |
| t | 113 | |
| m | 77 | 7.0% |
| o | 76 | 6.9% |
| v | 39 | 3.5% |
| s | 38 | 3.4% |
| p | 38 | 3.4% |
| Other values (4) | 151 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 39 | |
| S | 38 | |
| A | 38 | |
| J | 38 | |
| O | 37 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1293 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 229 | |
| b | 114 | 8.8% |
| r | 114 | 8.8% |
| u | 114 | 8.8% |
| t | 113 | 8.7% |
| m | 77 | 6.0% |
| o | 76 | 5.9% |
| N | 39 | 3.0% |
| v | 39 | 3.0% |
| s | 38 | 2.9% |
| Other values (9) | 340 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1293 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 229 | |
| b | 114 | 8.8% |
| r | 114 | 8.8% |
| u | 114 | 8.8% |
| t | 113 | 8.7% |
| m | 77 | 6.0% |
| o | 76 | 5.9% |
| N | 39 | 3.0% |
| v | 39 | 3.0% |
| s | 38 | 2.9% |
| Other values (9) | 340 |
| Distinct | 189 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14077.36316 |
| Minimum | 35 |
|---|---|
| Maximum | 276568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 35 |
|---|---|
| 5-th percentile | 69.25 |
| Q1 | 1065 |
| median | 4969 |
| Q3 | 13380 |
| 95-th percentile | 56080.6 |
| Maximum | 276568 |
| Range | 276533 |
| Interquartile range (IQR) | 12315 |
Descriptive statistics
| Standard deviation | 29771.68623 |
|---|---|
| Coefficient of variation (CV) | 2.114862414 |
| Kurtosis | 35.80165748 |
| Mean | 14077.36316 |
| Median Absolute Deviation (MAD) | 4302 |
| Skewness | 5.173273236 |
| Sum | 2674699 |
| Variance | 886353300.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3279 | 2 | 1.1% |
| 1770 | 1 | 0.5% |
| 6254 | 1 | 0.5% |
| 6908 | 1 | 0.5% |
| 15769 | 1 | 0.5% |
| 5044 | 1 | 0.5% |
| 5789 | 1 | 0.5% |
| 9619 | 1 | 0.5% |
| 2336 | 1 | 0.5% |
| 4715 | 1 | 0.5% |
| Other values (179) | 179 |
| Value | Count | Frequency (%) |
| 35 | 1 | |
| 36 | 1 | |
| 38 | 1 | |
| 44 | 1 | |
| 50 | 1 | |
| 52 | 1 | |
| 54 | 1 | |
| 55 | 1 | |
| 66 | 1 | |
| 67 | 1 |
| Value | Count | Frequency (%) |
| 276568 | 1 | |
| 152394 | 1 | |
| 138811 | 1 | |
| 105966 | 1 | |
| 99258 | 1 | |
| 93406 | 1 | |
| 90806 | 1 | |
| 73448 | 1 | |
| 64067 | 1 | |
| 57373 | 1 |
| Distinct | 183 |
|---|---|
| Distinct (%) | 96.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4865.805263 |
| Minimum | 2 |
|---|---|
| Maximum | 99526 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 11.45 |
| Q1 | 264.5 |
| median | 930 |
| Q3 | 4190.5 |
| 95-th percentile | 22736.1 |
| Maximum | 99526 |
| Range | 99524 |
| Interquartile range (IQR) | 3926 |
Descriptive statistics
| Standard deviation | 11348.52922 |
|---|---|
| Coefficient of variation (CV) | 2.332302385 |
| Kurtosis | 30.71189062 |
| Mean | 4865.805263 |
| Median Absolute Deviation (MAD) | 826 |
| Skewness | 4.888967218 |
| Sum | 924503 |
| Variance | 128789115.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9 | 3 | 1.6% |
| 8 | 2 | 1.1% |
| 593 | 2 | 1.1% |
| 123 | 2 | 1.1% |
| 341 | 2 | 1.1% |
| 163 | 2 | 1.1% |
| 6504 | 1 | 0.5% |
| 2510 | 1 | 0.5% |
| 2908 | 1 | 0.5% |
| 855 | 1 | 0.5% |
| Other values (173) | 173 |
| Value | Count | Frequency (%) |
| 2 | 1 | 0.5% |
| 3 | 1 | 0.5% |
| 4 | 1 | 0.5% |
| 5 | 1 | 0.5% |
| 8 | 2 | |
| 9 | 3 | |
| 11 | 1 | 0.5% |
| 12 | 1 | 0.5% |
| 13 | 1 | 0.5% |
| 14 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 99526 | 1 | |
| 59177 | 1 | |
| 57405 | 1 | |
| 42283 | 1 | |
| 40622 | 1 | |
| 36068 | 1 | |
| 32005 | 1 | |
| 27121 | 1 | |
| 25283 | 1 | |
| 23538 | 1 |
| Distinct | 42 |
|---|---|
| Distinct (%) | 22.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2721052632 |
| Minimum | 0.05 |
|---|---|
| Maximum | 0.47 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 0.09 |
| Q1 | 0.1925 |
| median | 0.285 |
| Q3 | 0.36 |
| 95-th percentile | 0.43 |
| Maximum | 0.47 |
| Range | 0.42 |
| Interquartile range (IQR) | 0.1675 |
Descriptive statistics
| Standard deviation | 0.1078936841 |
|---|---|
| Coefficient of variation (CV) | 0.3965145063 |
| Kurtosis | -0.9383087548 |
| Mean | 0.2721052632 |
| Median Absolute Deviation (MAD) | 0.085 |
| Skewness | -0.3031002304 |
| Sum | 51.7 |
| Variance | 0.01164104706 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=42)
| Value | Count | Frequency (%) |
| 0.34 | 10 | 5.3% |
| 0.37 | 9 | 4.7% |
| 0.35 | 8 | 4.2% |
| 0.24 | 7 | 3.7% |
| 0.25 | 7 | 3.7% |
| 0.09 | 7 | 3.7% |
| 0.23 | 7 | 3.7% |
| 0.39 | 7 | 3.7% |
| 0.26 | 7 | 3.7% |
| 0.3 | 7 | 3.7% |
| Other values (32) | 114 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | 0.5% |
| 0.06 | 1 | 0.5% |
| 0.07 | 4 | |
| 0.08 | 3 | |
| 0.09 | 7 | |
| 0.1 | 2 | 1.1% |
| 0.11 | 3 | |
| 0.12 | 4 | |
| 0.13 | 4 | |
| 0.14 | 5 |
| Value | Count | Frequency (%) |
| 0.47 | 2 | 1.1% |
| 0.45 | 3 | 1.6% |
| 0.44 | 3 | 1.6% |
| 0.43 | 4 | |
| 0.42 | 1 | 0.5% |
| 0.41 | 3 | 1.6% |
| 0.4 | 7 | |
| 0.39 | 7 | |
| 0.38 | 5 | |
| 0.37 | 9 |
| Distinct | 137 |
|---|---|
| Distinct (%) | 72.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 505.2421053 |
| Minimum | 0 |
|---|---|
| Maximum | 7563 |
| Zeros | 7 |
| Zeros (%) | 3.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 24 |
| median | 70.5 |
| Q3 | 428.25 |
| 95-th percentile | 2248.55 |
| Maximum | 7563 |
| Range | 7563 |
| Interquartile range (IQR) | 404.25 |
Descriptive statistics
| Standard deviation | 1052.202922 |
|---|---|
| Coefficient of variation (CV) | 2.082571723 |
| Kurtosis | 17.79051328 |
| Mean | 505.2421053 |
| Median Absolute Deviation (MAD) | 68.5 |
| Skewness | 3.81395678 |
| Sum | 95996 |
| Variance | 1107130.989 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7 | 3.7% |
| 2 | 5 | 2.6% |
| 24 | 5 | 2.6% |
| 1 | 4 | 2.1% |
| 25 | 4 | 2.1% |
| 14 | 4 | 2.1% |
| 13 | 3 | 1.6% |
| 3 | 3 | 1.6% |
| 26 | 3 | 1.6% |
| 61 | 3 | 1.6% |
| Other values (127) | 149 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 3 | |
| 4 | 1 | 0.5% |
| 7 | 2 | 1.1% |
| 9 | 1 | 0.5% |
| 10 | 1 | 0.5% |
| 11 | 1 | 0.5% |
| 12 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 7563 | 1 | |
| 5961 | 1 | |
| 5782 | 1 | |
| 4349 | 1 | |
| 4080 | 1 | |
| 2940 | 1 | |
| 2713 | 1 | |
| 2666 | 1 | |
| 2444 | 1 | |
| 2294 | 1 |
| Distinct | 21 |
|---|---|
| Distinct (%) | 11.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07973684211 |
| Minimum | 0 |
|---|---|
| Maximum | 0.5 |
| Zeros | 7 |
| Zeros (%) | 3.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.03 |
| Q1 | 0.05 |
| median | 0.07 |
| Q3 | 0.1 |
| 95-th percentile | 0.14 |
| Maximum | 0.5 |
| Range | 0.5 |
| Interquartile range (IQR) | 0.05 |
Descriptive statistics
| Standard deviation | 0.05285934426 |
|---|---|
| Coefficient of variation (CV) | 0.6629224693 |
| Kurtosis | 23.45682501 |
| Mean | 0.07973684211 |
| Median Absolute Deviation (MAD) | 0.02 |
| Skewness | 3.592692129 |
| Sum | 15.15 |
| Variance | 0.002794110276 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 0.05 | 27 | |
| 0.07 | 22 | |
| 0.06 | 19 | |
| 0.04 | 19 | |
| 0.09 | 17 | |
| 0.1 | 16 | |
| 0.08 | 14 | |
| 0.11 | 12 | |
| 0.12 | 12 | |
| 0.03 | 8 | 4.2% |
| Other values (11) | 24 |
| Value | Count | Frequency (%) |
| 0 | 7 | 3.7% |
| 0.01 | 1 | 0.5% |
| 0.03 | 8 | 4.2% |
| 0.04 | 19 | |
| 0.05 | 27 | |
| 0.06 | 19 | |
| 0.07 | 22 | |
| 0.08 | 14 | |
| 0.09 | 17 | |
| 0.1 | 16 |
| Value | Count | Frequency (%) |
| 0.5 | 1 | 0.5% |
| 0.33 | 1 | 0.5% |
| 0.28 | 1 | 0.5% |
| 0.21 | 1 | 0.5% |
| 0.19 | 1 | 0.5% |
| 0.17 | 2 | 1.1% |
| 0.15 | 2 | 1.1% |
| 0.14 | 4 | 2.1% |
| 0.13 | 3 | 1.6% |
| 0.12 | 12 |
| Distinct | 175 |
|---|---|
| Distinct (%) | 92.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3344.063158 |
| Minimum | 1 |
|---|---|
| Maximum | 43542 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 188.5 |
| median | 563.5 |
| Q3 | 2967 |
| 95-th percentile | 13223.55 |
| Maximum | 43542 |
| Range | 43541 |
| Interquartile range (IQR) | 2778.5 |
Descriptive statistics
| Standard deviation | 6524.606753 |
|---|---|
| Coefficient of variation (CV) | 1.951101533 |
| Kurtosis | 15.8262848 |
| Mean | 3344.063158 |
| Median Absolute Deviation (MAD) | 557 |
| Skewness | 3.615090827 |
| Sum | 635372 |
| Variance | 42570493.29 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6 | 4 | 2.1% |
| 5 | 3 | 1.6% |
| 1 | 3 | 1.6% |
| 3 | 3 | 1.6% |
| 52 | 2 | 1.1% |
| 111 | 2 | 1.1% |
| 8 | 2 | 1.1% |
| 134 | 2 | 1.1% |
| 1118 | 2 | 1.1% |
| 272 | 2 | 1.1% |
| Other values (165) | 165 |
| Value | Count | Frequency (%) |
| 1 | 3 | |
| 2 | 1 | 0.5% |
| 3 | 3 | |
| 4 | 1 | 0.5% |
| 5 | 3 | |
| 6 | 4 | |
| 7 | 1 | 0.5% |
| 8 | 2 | |
| 18 | 1 | 0.5% |
| 35 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 43542 | 1 | |
| 38273 | 1 | |
| 37729 | 1 | |
| 27336 | 1 | |
| 24149 | 1 | |
| 19371 | 1 | |
| 18641 | 1 | |
| 16946 | 1 | |
| 13746 | 1 | |
| 13278 | 1 |
| Distinct | 100 |
|---|---|
| Distinct (%) | 52.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7912631579 |
| Minimum | 0.14 |
|---|---|
| Maximum | 2.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0.14 |
|---|---|
| 5-th percentile | 0.279 |
| Q1 | 0.48 |
| median | 0.635 |
| Q3 | 1.1075 |
| 95-th percentile | 1.4755 |
| Maximum | 2.02 |
| Range | 1.88 |
| Interquartile range (IQR) | 0.6275 |
Descriptive statistics
| Standard deviation | 0.403312323 |
|---|---|
| Coefficient of variation (CV) | 0.50970694 |
| Kurtosis | -0.4407450849 |
| Mean | 0.7912631579 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 0.6533200925 |
| Sum | 150.34 |
| Variance | 0.1626608299 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.59 | 5 | 2.6% |
| 0.57 | 5 | 2.6% |
| 0.49 | 5 | 2.6% |
| 0.62 | 5 | 2.6% |
| 0.52 | 4 | 2.1% |
| 0.51 | 4 | 2.1% |
| 0.41 | 4 | 2.1% |
| 0.48 | 4 | 2.1% |
| 0.44 | 4 | 2.1% |
| 0.38 | 4 | 2.1% |
| Other values (90) | 146 |
| Value | Count | Frequency (%) |
| 0.14 | 1 | |
| 0.17 | 1 | |
| 0.19 | 1 | |
| 0.22 | 2 | |
| 0.23 | 2 | |
| 0.25 | 1 | |
| 0.26 | 1 | |
| 0.27 | 1 | |
| 0.29 | 1 | |
| 0.3 | 1 |
| Value | Count | Frequency (%) |
| 2.02 | 1 | |
| 1.92 | 1 | |
| 1.87 | 1 | |
| 1.62 | 1 | |
| 1.6 | 1 | |
| 1.55 | 1 | |
| 1.51 | 1 | |
| 1.49 | 2 | |
| 1.48 | 1 | |
| 1.47 | 1 |
| Distinct | 172 |
|---|---|
| Distinct (%) | 90.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2957.684211 |
| Minimum | 0 |
|---|---|
| Maximum | 42440 |
| Zeros | 8 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5.35 |
| Q1 | 144.5 |
| median | 459.5 |
| Q3 | 2672.25 |
| 95-th percentile | 13163 |
| Maximum | 42440 |
| Range | 42440 |
| Interquartile range (IQR) | 2527.75 |
Descriptive statistics
| Standard deviation | 5962.413097 |
|---|---|
| Coefficient of variation (CV) | 2.015905916 |
| Kurtosis | 17.41256614 |
| Mean | 2957.684211 |
| Median Absolute Deviation (MAD) | 451 |
| Skewness | 3.761989652 |
| Sum | 561960 |
| Variance | 35550369.94 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 4.2% |
| 173 | 3 | 1.6% |
| 165 | 2 | 1.1% |
| 202 | 2 | 1.1% |
| 22 | 2 | 1.1% |
| 7 | 2 | 1.1% |
| 76 | 2 | 1.1% |
| 295 | 2 | 1.1% |
| 67 | 2 | 1.1% |
| 162 | 2 | 1.1% |
| Other values (162) | 163 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 1 | 1 | 0.5% |
| 4 | 1 | 0.5% |
| 7 | 2 | 1.1% |
| 8 | 2 | 1.1% |
| 12 | 1 | 0.5% |
| 13 | 1 | 0.5% |
| 14 | 1 | 0.5% |
| 16 | 1 | 0.5% |
| 20 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 42440 | 1 | |
| 34518 | 1 | |
| 32668 | 1 | |
| 24071 | 1 | |
| 23857 | 1 | |
| 16555 | 1 | |
| 14565 | 1 | |
| 13744 | 1 | |
| 13699 | 1 | |
| 13262 | 1 |
| Distinct | 184 |
|---|---|
| Distinct (%) | 96.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63416.18058 |
| Minimum | 0 |
|---|---|
| Maximum | 886095.31 |
| Zeros | 7 |
| Zeros (%) | 3.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 108.7105 |
| Q1 | 2985.135 |
| median | 10274.105 |
| Q3 | 59345.195 |
| 95-th percentile | 284099.7585 |
| Maximum | 886095.31 |
| Range | 886095.31 |
| Interquartile range (IQR) | 56360.06 |
Descriptive statistics
| Standard deviation | 125414.6569 |
|---|---|
| Coefficient of variation (CV) | 1.97764444 |
| Kurtosis | 16.69701991 |
| Mean | 63416.18058 |
| Median Absolute Deviation (MAD) | 10072.2 |
| Skewness | 3.674198041 |
| Sum | 12049074.31 |
| Variance | 1.572883617 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7 | 3.7% |
| 136770.05 | 1 | 0.5% |
| 8585.47 | 1 | 0.5% |
| 55815.23 | 1 | 0.5% |
| 34980.16 | 1 | 0.5% |
| 40122.76 | 1 | 0.5% |
| 25311.15 | 1 | 0.5% |
| 25104.24 | 1 | 0.5% |
| 12245.37 | 1 | 0.5% |
| 9859.2 | 1 | 0.5% |
| Other values (174) | 174 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 5.96 | 1 | 0.5% |
| 28.93 | 1 | 0.5% |
| 83.2 | 1 | 0.5% |
| 139.89 | 1 | 0.5% |
| 147.75 | 1 | 0.5% |
| 157.97 | 1 | 0.5% |
| 168.54 | 1 | 0.5% |
| 235.27 | 1 | 0.5% |
| 261.4 | 1 | 0.5% |
| Value | Count | Frequency (%) |
| 886095.31 | 1 | |
| 725773.92 | 1 | |
| 677188.1 | 1 | |
| 500400.85 | 1 | |
| 497790.81 | 1 | |
| 345891.36 | 1 | |
| 321387.88 | 1 | |
| 294536.92 | 1 | |
| 285638.3 | 1 | |
| 284823.48 | 1 |
| Distinct | 188 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -386.3619158 |
| Minimum | -5672.271 |
|---|---|
| Maximum | 1507.685 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 151 |
| Negative (%) | 79.5% |
| Memory size | 1.6 KiB |
Quantile statistics
| Minimum | -5672.271 |
|---|---|
| 5-th percentile | -2028.99835 |
| Q1 | -294.9775 |
| median | -75.978 |
| Q3 | -6.0275 |
| 95-th percentile | 116.414 |
| Maximum | 1507.685 |
| Range | 7179.956 |
| Interquartile range (IQR) | 288.95 |
Descriptive statistics
| Standard deviation | 903.0737755 |
|---|---|
| Coefficient of variation (CV) | -2.337377828 |
| Kurtosis | 14.51111736 |
| Mean | -386.3619158 |
| Median Absolute Deviation (MAD) | 88.861 |
| Skewness | -3.389103267 |
| Sum | -73408.764 |
| Variance | 815542.244 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -1 | 2 | 1.1% |
| -6 | 2 | 1.1% |
| -267.086 | 1 | 0.5% |
| 168.373 | 1 | 0.5% |
| 337.125 | 1 | 0.5% |
| -79.595 | 1 | 0.5% |
| 342.979 | 1 | 0.5% |
| -265.424 | 1 | 0.5% |
| 97.764 | 1 | 0.5% |
| -27.854 | 1 | 0.5% |
| Other values (178) | 178 |
| Value | Count | Frequency (%) |
| -5672.271 | 1 | |
| -5605.297 | 1 | |
| -4606.713 | 1 | |
| -3478.644 | 1 | |
| -3211.121 | 1 | |
| -3012.91 | 1 | |
| -2380.616 | 1 | |
| -2240.076 | 1 | |
| -2170.044 | 1 | |
| -2086.3 | 1 |
| Value | Count | Frequency (%) |
| 1507.685 | 1 | |
| 766.859 | 1 | |
| 762.921 | 1 | |
| 342.979 | 1 | |
| 337.125 | 1 | |
| 308.975 | 1 | |
| 181.597 | 1 | |
| 168.373 | 1 | |
| 117.136 | 1 | |
| 116.783 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Ad Group | Month | Impressions | Clicks | CTR | Conversions | Conv Rate | Cost | CPC | Revenue | Sale Amount | P&L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Shop - 1:1 - Desk - [shop coupon code] | July | 16038 | 6504 | 0.41 | 1166 | 0.10 | 6669 | 1.03 | 6402 | 136770.05 | -267.086 |
| 1 | Shop - 1:1 - Desk - [shop coupon] | July | 36462 | 14367 | 0.39 | 2188 | 0.09 | 13746 | 0.96 | 13262 | 283215.21 | -483.951 |
| 2 | Shop - 1:1 - Desk - [shop discount code] | July | 3635 | 1458 | 0.40 | 248 | 0.09 | 1606 | 1.10 | 1723 | 39165.46 | 117.136 |
| 3 | Shop - 1:1 - Desk - [shop promo code] | July | 26185 | 10418 | 0.40 | 2294 | 0.12 | 13278 | 1.27 | 13042 | 284823.48 | -235.921 |
| 4 | Shop - 1:1 - Desk - [shop promo] | July | 808 | 282 | 0.35 | 61 | 0.15 | 391 | 1.39 | 337 | 7717.77 | -53.604 |
| 5 | Shop - 1:1 - Mob - [shop coupon code] | July | 46507 | 21756 | 0.47 | 1665 | 0.05 | 13157 | 0.60 | 8550 | 185824.49 | -4606.713 |
| 6 | Shop - 1:1 - Mob - [shop coupon] | July | 152394 | 59177 | 0.39 | 2666 | 0.04 | 19371 | 0.33 | 13699 | 294536.92 | -5672.271 |
| 7 | Shop - 1:1 - Mob - [shop discount code] | July | 9950 | 4283 | 0.43 | 347 | 0.05 | 2637 | 0.62 | 2038 | 46026.32 | -598.993 |
| 8 | Shop - 1:1 - Mob - [shop promo code] | July | 57373 | 27121 | 0.47 | 2940 | 0.07 | 16946 | 0.62 | 14565 | 321387.88 | -2380.616 |
| 9 | Shop - 1:1 - Mob - [shop promo] | July | 1875 | 706 | 0.38 | 69 | 0.07 | 485 | 0.69 | 409 | 8946.99 | -75.734 |
Last rows
| Ad Group | Month | Impressions | Clicks | CTR | Conversions | Conv Rate | Cost | CPC | Revenue | Sale Amount | P&L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180 | Shop - Phrase - Mob - Competitor | November | 127 | 32 | 0.25 | 2 | 0.04 | 18 | 0.59 | 7 | 139.89 | -11.005 |
| 181 | Shop - Phrase - Desk - Free Shipping | November | 85 | 9 | 0.11 | 0 | 0.00 | 2 | 0.32 | 0 | 0.00 | -2.000 |
| 182 | Shop - Phrase - Mob - Free Shipping | November | 209 | 31 | 0.15 | 2 | 0.05 | 7 | 0.23 | 7 | 147.75 | 0.389 |
| 183 | Shop - 1:1 - Mob - [shop promo] | November | 5828 | 1975 | 0.34 | 214 | 0.09 | 1118 | 0.57 | 1121 | 22936.40 | 3.104 |
| 184 | Shop - Exact - Mob - Offer | November | 6838 | 1235 | 0.18 | 85 | 0.07 | 641 | 0.52 | 676 | 14020.86 | 34.512 |
| 185 | Shop - Exact - Desk - Black Friday/Cyber Monday | November | 257 | 24 | 0.09 | 7 | 0.28 | 3 | 0.14 | 45 | 898.80 | 41.946 |
| 186 | Shop - 1:1 - Desk - [shop discount code] | November | 7254 | 2725 | 0.38 | 512 | 0.11 | 3182 | 1.17 | 3227 | 66672.29 | 45.468 |
| 187 | Shop - Exact - Desk - Coupon Code | November | 18526 | 5553 | 0.30 | 919 | 0.10 | 5982 | 1.08 | 6047 | 129556.90 | 64.552 |
| 188 | Shop - Exact - Mob - Black Friday/Cyber Monday | November | 3662 | 266 | 0.07 | 24 | 0.09 | 44 | 0.17 | 160 | 3268.63 | 115.963 |
| 189 | Shop - Exact - Desk - Promo Code | November | 25592 | 7726 | 0.30 | 1731 | 0.14 | 10914 | 1.41 | 11223 | 236665.59 | 308.975 |